package com.guigu.eduorder.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.guigu.eduorder.entity.Ab_user;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;


@Repository
public interface Ab_userMapper extends BaseMapper<Ab_user> {

    @Select("select * from ab_user where username =#{name} and salt =#{password} and state=0")
    Ab_user Selectlogin(String name, String password);

    @Select("select * from ab_user where phone =#{phone} and state=0")
    Ab_user Selectphonelogin(String phone);

    @Select("select * from ab_user where username =#{ab_username}")
    Ab_user SelectoneName(String ab_username);
}
